insert overwrite table jms_dim.dim_mysql_lmdm_sys_second_code
select
id
,code
,network_id
,network_name
,network_code
,country_id
,province_id
,city_id
,area_id
,town_id
,center_id
,center_name
,center_code
,center_province_id
,center_city_id
,center_area_id
,is_enable
,is_delete
,create_by
,update_by
,create_by_name
,update_by_name
,create_time
,update_time
,version
,sort
,effect_time
,invalid_time
,modified_time
from jms_ods.yl_cn_mysql_lmdm_sys_second_code where dt = '{{ execution_date | cst_ds_nodash }}'
 distribute by 1 ;